package com.bifang.common.vo.excel;

import com.bifang.common.vo.BasePageVO;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import java.util.List;
import lombok.Data;

/**
 * excel模板配置主表
 *
 * @author chenzh
 * @since 2021-02-01
 */
@Data
@ApiModel(value = "ExcelModel对象", description = "excel模板配置主表")
public class ExcelModelVO extends BasePageVO {

    @ApiModelProperty(value = "主键")
    private String id;

    @ApiModelProperty(value = "excel模板编码")
    private String modelCode;

    @ApiModelProperty(value = "excel模板名称")
    private String modelName;

    @ApiModelProperty(value = "标题字体颜色 0-64")
    private Short headerColor;

    @ApiModelProperty(value = "标题背景颜色 0-64")
    private Short headerBgColor;

    @ApiModelProperty(value = "数据字体颜色 0-64")
    private Short bodyColor;

    @ApiModelProperty(value = "字体背景颜色 0-64")
    private Short bodyBgColor;

    @ApiModelProperty(value = "xls或者xlsx")
    private String excelType;

    @ApiModelProperty(value = "是否大数据表格：0 否 1 是")
    private String bigFlag;

    @ApiModelProperty(value = "sheet表格名称")
    private String sheetName;

    @ApiModelProperty(value = "标题头行高")
    private Integer headerHeight;

    @ApiModelProperty(value = "数据行高")
    private Integer bodyHeight;

    @ApiModelProperty(value = "冻结行，从第一行开始")
    private Integer rowsplit;

    @ApiModelProperty(value = "冻结列，从第一列开始")
    private Integer colsplit;

    @ApiModelProperty(value = "excel分类")
    private String excelClass;

    @ApiModelProperty(value = "excel分类名称")
    private String excelClassName;

    @ApiModelProperty(value = "备注")
    private String remarks;

    @ApiModelProperty(value = "版本")
    private String version;

    @ApiModelProperty(value = "是否最新版本")
    private String newFlag;

    @ApiModelProperty(value = "标题行 从0开始")
    private Integer headerRowIndex;

    @ApiModelProperty(value = "数据起始行 从0开始 为空则是标题行+1")
    private Integer startRowIndex;

    @ApiModelProperty(value = "读取或插入数据的sheet表格序号")
    private Integer sheetIndex;

    @ApiModelProperty(value = "是否换行")
    private String wrapText;

    @ApiModelProperty(value = "字体大小")
    private Short fontSize;

    @ApiModelProperty(value = "字体")
    private String fontName;

    @ApiModelProperty(value = "边框粗细 0-13")
    private Short borderSize;

    @ApiModelProperty(value = "边框颜色 0-64")
    private Short borderColor;

    @ApiModelProperty(value = "exlel模板字段列表")
    private List<ExcelParamVO> paramVOList;
}
